Pandas Profiling Report

Dataset statistics

Number of variables	17
Number of observations	42896
Missing cells	52072
Missing cells (%)	7.1%
Duplicate rows	906
Duplicate rows (%)	2.1%
Total size in memory	5.6 MiB
Average record size in memory	136.0 B

Variable types

Numeric	11
Categorical	6

Alerts

`type` has constant value "audio_features"	Constant
Dataset has 906 (2.1%) duplicate rows	Duplicates
`song_name` has a high cardinality: 15439 distinct values	High cardinality
`title` has a high cardinality: 132 distinct values	High cardinality
`energy` is highly overall correlated with `loudness` and 1 other fields	High correlation
`loudness` is highly overall correlated with `energy`	High correlation
`acousticness` is highly overall correlated with `energy` and 1 other fields	High correlation
`instrumentalness` is highly overall correlated with `acousticness` and 1 other fields	High correlation
`duration_ms` is highly overall correlated with `instrumentalness`	High correlation
`time_signature` is highly imbalanced (84.3%)	Imbalance
`loudness` has 9170 (21.4%) missing values	Missing
`song_name` has 21085 (49.2%) missing values	Missing
`title` has 21817 (50.9%) missing values	Missing
`song_name` is uniformly distributed	Uniform
`key` has 3520 (8.2%) zeros	Zeros
`instrumentalness` has 11473 (26.7%) zeros	Zeros

Reproduction

Analysis started	2023-01-12 08:12:19.903619
Analysis finished	2023-01-12 08:12:56.871020
Duration	36.97 seconds
Software version	pandas-profiling vdev
Download configuration	config.json

danceability
Real number (ℝ)

Distinct	921
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.63933611

Minimum	0.0651
Maximum	0.988
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.2 KiB

Quantile statistics

Minimum	0.0651
5-th percentile	0.378
Q1	0.524
median	0.646
Q3	0.766
95-th percentile	0.878
Maximum	0.988
Range	0.9229
Interquartile range (IQR)	0.242

Descriptive statistics

Standard deviation	0.15658499
Coefficient of variation (CV)	0.24491811
Kurtosis	-0.48618557
Mean	0.63933611
Median Absolute Deviation (MAD)	0.121
Skewness	-0.265132
Sum	27424.962
Variance	0.024518859
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.804	193	0.4%
0.808	166	0.4%
0.8	154	0.4%
0.802	153	0.4%
0.805	150	0.3%
0.803	150	0.3%
0.809	141	0.3%
0.81	136	0.3%
0.807	134	0.3%
0.792	126	0.3%
Other values (911)	41393	96.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0651	2	< 0.1%
0.0753	1	< 0.1%
0.0891	2	< 0.1%
0.0979	1	< 0.1%
0.106	2	< 0.1%
0.111	1	< 0.1%
0.116	1	< 0.1%
0.119	1	< 0.1%
0.121	1	< 0.1%
0.123	1	< 0.1%

Value	Count	Frequency (%)
0.988	3	< 0.1%
0.985	4	< 0.1%
0.984	1	< 0.1%
0.983	2	< 0.1%
0.982	1	< 0.1%
0.981	1	< 0.1%
0.98	2	< 0.1%
0.979	2	< 0.1%
0.978	3	< 0.1%
0.977	2	< 0.1%

energy
Real number (ℝ)

Distinct	955
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.76256045

Minimum	0.000243
Maximum	1
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.2 KiB

Quantile statistics

Minimum	0.000243
5-th percentile	0.425
Q1	0.632
median	0.803
Q3	0.923
95-th percentile	0.982
Maximum	1
Range	0.999757
Interquartile range (IQR)	0.291

Descriptive statistics

Standard deviation	0.18369117
Coefficient of variation (CV)	0.24088736
Kurtosis	-0.20130099
Mean	0.76256045
Median Absolute Deviation (MAD)	0.135
Skewness	-0.73716286
Sum	32710.793
Variance	0.033742448
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.977	191	0.4%
0.953	172	0.4%
0.988	171	0.4%
0.97	170	0.4%
0.956	169	0.4%
0.924	165	0.4%
0.963	162	0.4%
0.98	159	0.4%
0.951	159	0.4%
0.942	158	0.4%
Other values (945)	41220	96.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.000243	2	< 0.1%
0.000602	1	< 0.1%
0.0127	1	< 0.1%
0.0148	1	< 0.1%
0.0223	1	< 0.1%
0.0279	2	< 0.1%
0.0297	1	< 0.1%
0.0321	1	< 0.1%
0.0393	1	< 0.1%
0.0453	1	< 0.1%

Value	Count	Frequency (%)
1	5	< 0.1%
0.999	22	0.1%
0.999	3	< 0.1%
0.998	87	0.2%
0.997	94	0.2%
0.996	100	0.2%
0.995	123	0.3%
0.994	144	0.3%
0.994	4	< 0.1%
0.993	133	0.3%

key
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.3685658

Minimum	0
Maximum	11
Zeros	3520
Zeros (%)	8.2%
Negative	0
Negative (%)	0.0%
Memory size	335.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	6
Q3	9
95-th percentile	11
Maximum	11
Range	11
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	3.6649926
Coefficient of variation (CV)	0.68267629
Kurtosis	-1.365958
Mean	5.3685658
Median Absolute Deviation (MAD)	4
Skewness	-0.00095694629
Sum	230290
Variance	13.432171
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	7641	17.8%
7	4332	10.1%
11	4197	9.8%
6	3767	8.8%
0	3520	8.2%
8	3405	7.9%
10	3294	7.7%
9	3293	7.7%
2	3093	7.2%
5	3047	7.1%
Other values (2)	3307	7.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3520	8.2%
1	7641	17.8%
2	3093	7.2%
3	910	2.1%
4	2397	5.6%
5	3047	7.1%
6	3767	8.8%
7	4332	10.1%
8	3405	7.9%
9	3293	7.7%

Value	Count	Frequency (%)
11	4197	9.8%
10	3294	7.7%
9	3293	7.7%
8	3405	7.9%
7	4332	10.1%
6	3767	8.8%
5	3047	7.1%
4	2397	5.6%
3	910	2.1%
2	3093	7.2%

loudness
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	11257
Distinct (%)	33.4%
Missing	9170
Missing (%)	21.4%
Infinite	0
Infinite (%)	0.0%
Mean	-6.4638994

Minimum	-32.929
Maximum	3.148
Zeros	1
Zeros (%)	< 0.1%
Negative	33562
Negative (%)	78.2%
Memory size	335.2 KiB

Quantile statistics

Minimum	-32.929
5-th percentile	-11.626
Q1	-8.165
median	-6.2285
Q3	-4.52
95-th percentile	-2.00625
Maximum	3.148
Range	36.077
Interquartile range (IQR)	3.645

Descriptive statistics

Standard deviation	2.9381711
Coefficient of variation (CV)	-0.45455087
Kurtosis	1.4448485
Mean	-6.4638994
Median Absolute Deviation (MAD)	1.817
Skewness	-0.62893063
Sum	-218001.47
Variance	8.6328493
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-6.142	19	< 0.1%
-6.186	17	< 0.1%
-5.892	16	< 0.1%
-5.943	16	< 0.1%
-5.572	15	< 0.1%
-5.334	15	< 0.1%
-5.531	15	< 0.1%
-4.162	15	< 0.1%
-7.641	15	< 0.1%
-5.545	14	< 0.1%
Other values (11247)	33569	78.3%
(Missing)	9170	21.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-32.929	1	< 0.1%
-26.172	1	< 0.1%
-26.113	1	< 0.1%
-24.694	1	< 0.1%
-24.563	1	< 0.1%
-24.203	1	< 0.1%
-23.577	1	< 0.1%
-23.39	1	< 0.1%
-23.385	1	< 0.1%
-23.035	1	< 0.1%

Value	Count	Frequency (%)
3.148	1	< 0.1%
2.499	1	< 0.1%
2.363	1	< 0.1%
2.185	1	< 0.1%
1.949	1	< 0.1%
1.877	1	< 0.1%
1.851	1	< 0.1%
1.85	1	< 0.1%
1.833	1	< 0.1%
1.792	1	< 0.1%

mode
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	335.2 KiB

1	23571
0	19325

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	42896
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	23571	54.9%
0	19325	45.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	23571	54.9%
0	19325	45.1%

Most occurring characters

Value	Count	Frequency (%)
1	23571	54.9%
0	19325	45.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	42896	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	23571	54.9%
0	19325	45.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	42896	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	23571	54.9%
0	19325	45.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	42896	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	23571	54.9%
0	19325	45.1%

speechiness
Real number (ℝ)

Distinct	1474
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.13644625

Minimum	0.0227
Maximum	0.946
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.2 KiB

Quantile statistics

Minimum	0.0227
5-th percentile	0.0348
Q1	0.0491
median	0.0754
Q3	0.193
95-th percentile	0.398
Maximum	0.946
Range	0.9233
Interquartile range (IQR)	0.1439

Descriptive statistics

Standard deviation	0.12597627
Coefficient of variation (CV)	0.92326664
Kurtosis	2.889166
Mean	0.13644625
Median Absolute Deviation (MAD)	0.0347
Skewness	1.6715108
Sum	5852.9984
Variance	0.015870021
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.102	123	0.3%
0.106	116	0.3%
0.105	115	0.3%
0.109	113	0.3%
0.111	112	0.3%
0.11	110	0.3%
0.113	106	0.2%
0.107	104	0.2%
0.114	100	0.2%
0.124	96	0.2%
Other values (1464)	41801	97.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0227	2	< 0.1%
0.0232	2	< 0.1%
0.0235	1	< 0.1%
0.0238	1	< 0.1%
0.0239	1	< 0.1%
0.0241	1	< 0.1%
0.0242	3	< 0.1%
0.0243	1	< 0.1%
0.0244	2	< 0.1%
0.0245	1	< 0.1%

Value	Count	Frequency (%)
0.946	1	< 0.1%
0.944	1	< 0.1%
0.914	1	< 0.1%
0.908	3	< 0.1%
0.906	1	< 0.1%
0.905	1	< 0.1%
0.902	2	< 0.1%
0.898	1	< 0.1%
0.89	1	< 0.1%
0.888	1	< 0.1%

acousticness
Real number (ℝ)

Distinct	4707
Distinct (%)	11.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.096260315

Minimum	1.07 × 10^-6
Maximum	0.988
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.2 KiB

Quantile statistics

Minimum	1.07 × 10^-6
5-th percentile	8.9475 × 10^-5
Q1	0.00173
median	0.0164
Q3	0.107
95-th percentile	0.497
Maximum	0.988
Range	0.98799893
Interquartile range (IQR)	0.10527

Descriptive statistics

Standard deviation	0.17084273
Coefficient of variation (CV)	1.7747992
Kurtosis	6.5271008
Mean	0.096260315
Median Absolute Deviation (MAD)	0.016194
Skewness	2.5299953
Sum	4129.1825
Variance	0.029187238
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.128	75	0.2%
0.114	74	0.2%
0.106	69	0.2%
0.125	69	0.2%
0.0138	68	0.2%
0.105	61	0.1%
0.0105	60	0.1%
0.102	57	0.1%
0.111	57	0.1%
0.133	56	0.1%
Other values (4697)	42250	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.07 × 10^-6	1	< 0.1%
1.14 × 10^-6	1	< 0.1%
1.21 × 10^-6	1	< 0.1%
1.46 × 10^-6	1	< 0.1%
1.81 × 10^-6	1	< 0.1%
1.83 × 10^-6	1	< 0.1%
1.93 × 10^-6	1	< 0.1%
2.14 × 10^-6	1	< 0.1%
2.43 × 10^-6	1	< 0.1%
2.46 × 10^-6	1	< 0.1%

Value	Count	Frequency (%)
0.988	1	< 0.1%
0.987	1	< 0.1%
0.986	2	< 0.1%
0.985	1	< 0.1%
0.984	1	< 0.1%
0.983	1	< 0.1%
0.982	2	< 0.1%
0.98	1	< 0.1%
0.978	3	< 0.1%
0.976	3	< 0.1%

instrumentalness
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	4867
Distinct (%)	11.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.28322936

Minimum	0
Maximum	0.989
Zeros	11473
Zeros (%)	26.7%
Negative	0
Negative (%)	0.0%
Memory size	335.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.00596
Q3	0.722
95-th percentile	0.909
Maximum	0.989
Range	0.989
Interquartile range (IQR)	0.722

Descriptive statistics

Standard deviation	0.37081022
Coefficient of variation (CV)	1.3092224
Kurtosis	-1.2495296
Mean	0.28322936
Median Absolute Deviation (MAD)	0.00596
Skewness	0.75166777
Sum	12149.407
Variance	0.13750022
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	11473	26.7%
0.871	93	0.2%
0.897	90	0.2%
0.901	85	0.2%
0.895	85	0.2%
0.858	79	0.2%
0.874	79	0.2%
0.865	78	0.2%
0.892	77	0.2%
0.883	77	0.2%
Other values (4857)	30680	71.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	11473	26.7%
1 × 10^-6	5	< 0.1%
1.01 × 10^-6	13	< 0.1%
1.02 × 10^-6	13	< 0.1%
1.03 × 10^-6	13	< 0.1%
1.04 × 10^-6	16	< 0.1%
1.05 × 10^-6	7	< 0.1%
1.06 × 10^-6	13	< 0.1%
1.07 × 10^-6	9	< 0.1%
1.08 × 10^-6	7	< 0.1%

Value	Count	Frequency (%)
0.989	3	< 0.1%
0.988	1	< 0.1%
0.987	1	< 0.1%
0.986	1	< 0.1%
0.985	1	< 0.1%
0.983	1	< 0.1%
0.982	1	< 0.1%
0.981	6	< 0.1%
0.979	2	< 0.1%
0.978	4	< 0.1%

liveness
Real number (ℝ)

Distinct	1737
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.21408004

Minimum	0.0107
Maximum	0.988
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.2 KiB

Quantile statistics

Minimum	0.0107
5-th percentile	0.0615
Q1	0.0996
median	0.135
Q3	0.294
95-th percentile	0.61825
Maximum	0.988
Range	0.9773
Interquartile range (IQR)	0.1944

Descriptive statistics

Standard deviation	0.17546346
Coefficient of variation (CV)	0.81961618
Kurtosis	3.0811814
Mean	0.21408004
Median Absolute Deviation (MAD)	0.0546
Skewness	1.7803261
Sum	9183.1773
Variance	0.030787427
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.111	689	1.6%
0.109	487	1.1%
0.107	455	1.1%
0.11	443	1.0%
0.106	432	1.0%
0.105	368	0.9%
0.102	364	0.8%
0.114	349	0.8%
0.113	348	0.8%
0.115	316	0.7%
Other values (1727)	38645	90.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0107	1	< 0.1%
0.0121	3	< 0.1%
0.0135	1	< 0.1%
0.0141	3	< 0.1%
0.0147	1	< 0.1%
0.0149	1	< 0.1%
0.0153	3	< 0.1%
0.0159	1	< 0.1%
0.0182	1	< 0.1%
0.0188	1	< 0.1%

Value	Count	Frequency (%)
0.988	1	< 0.1%
0.981	2	< 0.1%
0.979	1	< 0.1%
0.978	3	< 0.1%
0.976	1	< 0.1%
0.975	5	< 0.1%
0.973	2	< 0.1%
0.97	1	< 0.1%
0.969	1	< 0.1%
0.968	1	< 0.1%

valence
Real number (ℝ)

Distinct	1716
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.3571699

Minimum	0.0187
Maximum	0.988
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.2 KiB

Quantile statistics

Minimum	0.0187
5-th percentile	0.0436
Q1	0.161
median	0.322
Q3	0.522
95-th percentile	0.797
Maximum	0.988
Range	0.9693
Interquartile range (IQR)	0.361

Descriptive statistics

Standard deviation	0.23325546
Coefficient of variation (CV)	0.65306582
Kurtosis	-0.60890607
Mean	0.3571699
Median Absolute Deviation (MAD)	0.175
Skewness	0.54957366
Sum	15321.16
Variance	0.054408108
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.142	99	0.2%
0.158	97	0.2%
0.144	93	0.2%
0.186	92	0.2%
0.141	91	0.2%
0.175	90	0.2%
0.15	88	0.2%
0.178	88	0.2%
0.152	87	0.2%
0.159	87	0.2%
Other values (1706)	41984	97.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0187	2	< 0.1%
0.0196	3	< 0.1%
0.0199	1	< 0.1%
0.0206	3	< 0.1%
0.0218	3	< 0.1%
0.0228	1	< 0.1%
0.0235	1	< 0.1%
0.0236	1	< 0.1%
0.0237	1	< 0.1%
0.0239	2	< 0.1%

Value	Count	Frequency (%)
0.988	1	< 0.1%
0.98	3	< 0.1%
0.979	1	< 0.1%
0.976	2	< 0.1%
0.975	4	< 0.1%
0.974	2	< 0.1%
0.973	1	< 0.1%
0.972	3	< 0.1%
0.971	4	< 0.1%
0.97	5	< 0.1%

tempo
Real number (ℝ)

Distinct	15569
Distinct (%)	36.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	147.49209

Minimum	57.967
Maximum	220.29
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.2 KiB

Quantile statistics

Minimum	57.967
5-th percentile	115.82175
Q1	129.91875
median	144.9705
Q3	161.5975
95-th percentile	192.8865
Maximum	220.29
Range	162.323
Interquartile range (IQR)	31.67875

Descriptive statistics

Standard deviation	23.861654
Coefficient of variation (CV)	0.1617826
Kurtosis	0.10894812
Mean	147.49209
Median Absolute Deviation (MAD)	15.455
Skewness	0.47899078
Sum	6326820.5
Variance	569.37851
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
150.02	59	0.1%
125	57	0.1%
149.998	51	0.1%
125.002	50	0.1%
128	49	0.1%
150	48	0.1%
149.992	47	0.1%
125.007	46	0.1%
123.999	46	0.1%
128.005	44	0.1%
Other values (15559)	42399	98.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
57.967	1	< 0.1%
61.309	1	< 0.1%
64.331	1	< 0.1%
64.934	1	< 0.1%
64.95	1	< 0.1%
66.424	1	< 0.1%
67.003	1	< 0.1%
69.986	1	< 0.1%
70.022	1	< 0.1%
70.231	1	< 0.1%

Value	Count	Frequency (%)
220.29	1	< 0.1%
220.232	1	< 0.1%
220.216	1	< 0.1%
220.154	1	< 0.1%
220.152	1	< 0.1%
220.148	2	< 0.1%
220.138	1	< 0.1%
220.13	1	< 0.1%
220.112	1	< 0.1%
220.102	1	< 0.1%

type
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	335.2 KiB

audio_features	42896

Length

Max length	14
Median length	14
Mean length	14
Min length	14

Characters and Unicode

Total characters	600544
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	audio_features
2nd row	audio_features
3rd row	audio_features
4th row	audio_features
5th row	audio_features

Common Values

Value	Count	Frequency (%)
audio_features	42896	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
audio_features	42896	100.0%

Most occurring characters

Value	Count	Frequency (%)
a	85792	14.3%
u	85792	14.3%
e	85792	14.3%
d	42896	7.1%
i	42896	7.1%
o	42896	7.1%
_	42896	7.1%
f	42896	7.1%
t	42896	7.1%
r	42896	7.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	557648	92.9%
Connector Punctuation	42896	7.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	85792	15.4%
u	85792	15.4%
e	85792	15.4%
d	42896	7.7%
i	42896	7.7%
o	42896	7.7%
f	42896	7.7%
t	42896	7.7%
r	42896	7.7%
s	42896	7.7%

Connector Punctuation

Value	Count	Frequency (%)
_	42896	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	557648	92.9%
Common	42896	7.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	85792	15.4%
u	85792	15.4%
e	85792	15.4%
d	42896	7.7%
i	42896	7.7%
o	42896	7.7%
f	42896	7.7%
t	42896	7.7%
r	42896	7.7%
s	42896	7.7%

Common

Value	Count	Frequency (%)
_	42896	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	600544	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	85792	14.3%
u	85792	14.3%
e	85792	14.3%
d	42896	7.1%
i	42896	7.1%
o	42896	7.1%
_	42896	7.1%
f	42896	7.1%
t	42896	7.1%
r	42896	7.1%

duration_ms
Real number (ℝ)

Distinct	26261
Distinct (%)	61.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	250913.57

Minimum	25600
Maximum	913052
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.2 KiB

Quantile statistics

Minimum	25600
5-th percentile	121186
Q1	179971.25
median	224663
Q3	301288.5
95-th percentile	457973.25
Maximum	913052
Range	887452
Interquartile range (IQR)	121317.25

Descriptive statistics

Standard deviation	102979.76
Coefficient of variation (CV)	0.41041926
Kurtosis	0.49528913
Mean	250913.57
Median Absolute Deviation (MAD)	54250
Skewness	0.95262368
Sum	1.0763189 × 10¹⁰
Variance	1.0604831 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
192000	105	0.2%
240000	87	0.2%
224000	68	0.2%
211200	57	0.1%
230400	57	0.1%
172800	52	0.1%
217600	49	0.1%
236800	43	0.1%
268800	43	0.1%
168000	39	0.1%
Other values (26251)	42296	98.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
25600	1	< 0.1%
35862	1	< 0.1%
38333	1	< 0.1%
41290	1	< 0.1%
42133	1	< 0.1%
43807	1	< 0.1%
48107	1	< 0.1%
48423	1	< 0.1%
48667	1	< 0.1%
49227	1	< 0.1%

Value	Count	Frequency (%)
913052	1	< 0.1%
894386	1	< 0.1%
855502	1	< 0.1%
847302	1	< 0.1%
821168	1	< 0.1%
774294	1	< 0.1%
757972	1	< 0.1%
752000	1	< 0.1%
728413	1	< 0.1%
723573	2	< 0.1%

time_signature
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	335.2 KiB

4	40999
3	1227
5	519
1	151

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	42896
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4
2nd row	4
3rd row	4
4th row	3
5th row	4

Common Values

Value	Count	Frequency (%)
4	40999	95.6%
3	1227	2.9%
5	519	1.2%
1	151	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
4	40999	95.6%
3	1227	2.9%
5	519	1.2%
1	151	0.4%

Most occurring characters

Value	Count	Frequency (%)
4	40999	95.6%
3	1227	2.9%
5	519	1.2%
1	151	0.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	42896	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
4	40999	95.6%
3	1227	2.9%
5	519	1.2%
1	151	0.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	42896	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
4	40999	95.6%
3	1227	2.9%
5	519	1.2%
1	151	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	42896	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
4	40999	95.6%
3	1227	2.9%
5	519	1.2%
1	151	0.4%

genre
Categorical

Distinct	15
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	335.2 KiB

Underground Rap	5948
Dark Trap	4634
Hiphop	3080
trance	3038
techhouse	3019
Other values (10)	23177

Length

Max length	15
Median length	10
Mean length	7.6035761
Min length	3

Characters and Unicode

Total characters	326163
Distinct characters	29
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Dark Trap
2nd row	Dark Trap
3rd row	Dark Trap
4th row	Dark Trap
5th row	Dark Trap

Common Values

Value	Count	Frequency (%)
Underground Rap	5948	13.9%
Dark Trap	4634	10.8%
Hiphop	3080	7.2%
trance	3038	7.1%
techhouse	3019	7.0%
dnb	3017	7.0%
trap	3014	7.0%
techno	3007	7.0%
psytrance	3003	7.0%
hardstyle	2981	6.9%
Other values (5)	8155	19.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
trap	9632	17.4%
rap	7818	14.1%
underground	5948	10.7%
dark	4634	8.4%
hiphop	3080	5.6%
trance	3038	5.5%
techhouse	3019	5.4%
dnb	3017	5.4%
techno	3007	5.4%
psytrance	3003	5.4%
Other values (5)	9266	16.7%

Most occurring characters

Value	Count	Frequency (%)
r	35184	10.8%
a	33090	10.1%
p	27081	8.3%
n	26089	8.0%
e	25999	8.0%
t	20046	6.1%
d	17894	5.5%
o	17227	5.3%
h	15106	4.6%
	12566	3.9%
Other values (19)	95881	29.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	277086	85.0%
Uppercase Letter	36511	11.2%
Space Separator	12566	3.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	35184	12.7%
a	33090	11.9%
p	27081	9.8%
n	26089	9.4%
e	25999	9.4%
t	20046	7.2%
d	17894	6.5%
o	17227	6.2%
h	15106	5.5%
c	12067	4.4%
Other values (9)	47303	17.1%

Uppercase Letter

Value	Count	Frequency (%)
R	9946	27.2%
T	6618	18.1%
U	5948	16.3%
D	4634	12.7%
H	3080	8.4%
B	2128	5.8%
M	1984	5.4%
E	1705	4.7%
P	468	1.3%

Space Separator

Value	Count	Frequency (%)
	12566	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	313597	96.1%
Common	12566	3.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	35184	11.2%
a	33090	10.6%
p	27081	8.6%
n	26089	8.3%
e	25999	8.3%
t	20046	6.4%
d	17894	5.7%
o	17227	5.5%
h	15106	4.8%
c	12067	3.8%
Other values (18)	83814	26.7%

Common

Value	Count	Frequency (%)
	12566	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	326163	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	35184	10.8%
a	33090	10.1%
p	27081	8.3%
n	26089	8.0%
e	25999	8.0%
t	20046	6.1%
d	17894	5.5%
o	17227	5.3%
h	15106	4.6%
	12566	3.9%
Other values (19)	95881	29.4%

song_name
Categorical

HIGH CARDINALITY MISSING UNIFORM

Distinct	15439
Distinct (%)	70.8%
Missing	21085
Missing (%)	49.2%
Memory size	335.2 KiB

Forever	14
Lost	12
Hollow	12
Numb	12
Revenge	11
Other values (15434)	21750

Length

Max length	138
Median length	94
Mean length	15.5058
Min length	1

Characters and Unicode

Total characters	338197
Distinct characters	190
Distinct categories	15 ?
Distinct scripts	8 ?
Distinct blocks	9 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	11537 ?
Unique (%)	52.9%

Sample

1st row	Mercury: Retrograde
2nd row	Pathology
3rd row	Symbiote
4th row	ProductOfDrugs (Prod. The Virus and Antidote)
5th row	Venom

Common Values

Value	Count	Frequency (%)
Forever	14	< 0.1%
Lost	12	< 0.1%
Hollow	12	< 0.1%
Numb	12	< 0.1%
Revenge	11	< 0.1%
Scars	11	< 0.1%
PTSD	11	< 0.1%
Alone	11	< 0.1%
Runaway	11	< 0.1%
Leave Me Alone	10	< 0.1%
Other values (15429)	21696	50.6%
(Missing)	21085	49.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
feat	2494	4.0%
the	1698	2.7%
	1655	2.6%
you	760	1.2%
me	759	1.2%
i	725	1.2%
a	589	0.9%
my	514	0.8%
it	500	0.8%
of	467	0.7%
Other values (10934)	52297	83.7%

Most occurring characters

Value	Count	Frequency (%)
	40647	12.0%
e	29068	8.6%
a	19569	5.8%
o	17404	5.1%
t	16500	4.9%
i	15879	4.7%
n	13890	4.1%
r	12634	3.7%
l	10336	3.1%
s	10038	3.0%
Other values (180)	152232	45.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	207102	61.2%
Uppercase Letter	71342	21.1%
Space Separator	40647	12.0%
Other Punctuation	7651	2.3%
Open Punctuation	3463	1.0%
Close Punctuation	3460	1.0%
Decimal Number	3109	0.9%
Dash Punctuation	851	0.3%
Currency Symbol	363	0.1%
Math Symbol	118	< 0.1%
Other values (5)	91	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	29068	14.0%
a	19569	9.4%
o	17404	8.4%
t	16500	8.0%
i	15879	7.7%
n	13890	6.7%
r	12634	6.1%
l	10336	5.0%
s	10038	4.8%
h	8056	3.9%
Other values (63)	53728	25.9%

Uppercase Letter

Value	Count	Frequency (%)
T	5662	7.9%
S	5232	7.3%
A	4274	6.0%
M	4123	5.8%
I	4024	5.6%
B	3928	5.5%
L	3859	5.4%
D	3822	5.4%
R	3452	4.8%
C	3212	4.5%
Other values (39)	29754	41.7%

Other Letter

Value	Count	Frequency (%)
天	1	5.3%
ד	1	5.3%
ה	1	5.3%
מ	1	5.3%
ו	1	5.3%
ס	1	5.3%
복	1	5.3%
스	1	5.3%
행	1	5.3%
강	1	5.3%
Other values (9)	9	47.4%

Other Punctuation

Value	Count	Frequency (%)
.	3783	49.4%
'	1446	18.9%
&	868	11.3%
,	699	9.1%
!	259	3.4%
?	169	2.2%
/	156	2.0%
*	97	1.3%
"	89	1.2%
:	44	0.6%
Other values (7)	41	0.5%

Decimal Number

Value	Count	Frequency (%)
2	627	20.2%
0	621	20.0%
1	579	18.6%
4	254	8.2%
3	223	7.2%
5	199	6.4%
6	197	6.3%
9	194	6.2%
8	113	3.6%
7	102	3.3%

Math Symbol

Value	Count	Frequency (%)
+	63	53.4%
\|	44	37.3%
<	7	5.9%
>	3	2.5%
=	1	0.8%

Open Punctuation

Value	Count	Frequency (%)
(	3375	97.5%
[	87	2.5%
{	1	< 0.1%

Close Punctuation

Value	Count	Frequency (%)
)	3374	97.5%
]	85	2.5%
}	1	< 0.1%

Initial Punctuation

Value	Count	Frequency (%)
“	2	50.0%
⸉	1	25.0%
‘	1	25.0%

Dash Punctuation

Value	Count	Frequency (%)
-	850	99.9%
–	1	0.1%

Final Punctuation

Value	Count	Frequency (%)
’	39	95.1%
”	2	4.9%

Space Separator

Value	Count	Frequency (%)
	40647	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	363	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	26	100.0%

Other Symbol

Value	Count	Frequency (%)
°	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	278097	82.2%
Common	59734	17.7%
Cyrillic	345	0.1%
Hangul	7	< 0.1%
Hebrew	5	< 0.1%
Katakana	5	< 0.1%
Greek	2	< 0.1%
Han	2	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	29068	10.5%
a	19569	7.0%
o	17404	6.3%
t	16500	5.9%
i	15879	5.7%
n	13890	5.0%
r	12634	4.5%
l	10336	3.7%
s	10038	3.6%
h	8056	2.9%
Other values (69)	124723	44.8%

Common

Value	Count	Frequency (%)
	40647	68.0%
.	3783	6.3%
(	3375	5.7%
)	3374	5.6%
'	1446	2.4%
&	868	1.5%
-	850	1.4%
,	699	1.2%
2	627	1.0%
0	621	1.0%
Other values (39)	3444	5.8%

Cyrillic

Value	Count	Frequency (%)
е	37	10.7%
а	31	9.0%
о	29	8.4%
и	23	6.7%
н	23	6.7%
р	20	5.8%
с	16	4.6%
у	12	3.5%
л	11	3.2%
т	11	3.2%
Other values (31)	132	38.3%

Hangul

Value	Count	Frequency (%)
복	1	14.3%
스	1	14.3%
행	1	14.3%
강	1	14.3%
남	1	14.3%
타	1	14.3%
일	1	14.3%

Hebrew

Value	Count	Frequency (%)
ד	1	20.0%
ה	1	20.0%
מ	1	20.0%
ו	1	20.0%
ס	1	20.0%

Katakana

Value	Count	Frequency (%)
ム	1	20.0%
ス	1	20.0%
テ	1	20.0%
ィ	1	20.0%
ネ	1	20.0%

Greek

Value	Count	Frequency (%)
Δ	1	50.0%
Ξ	1	50.0%

Han

Value	Count	Frequency (%)
天	1	50.0%
泳	1	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	337682	99.8%
Cyrillic	345	0.1%
None	98	< 0.1%
Punctuation	52	< 0.1%
Hangul	7	< 0.1%
Hebrew	5	< 0.1%
Katakana	5	< 0.1%
CJK	2	< 0.1%
Sup Punctuation	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	40647	12.0%
e	29068	8.6%
a	19569	5.8%
o	17404	5.2%
t	16500	4.9%
i	15879	4.7%
n	13890	4.1%
r	12634	3.7%
l	10336	3.1%
s	10038	3.0%
Other values (82)	151717	44.9%

Punctuation

Value	Count	Frequency (%)
’	39	75.0%
•	5	9.6%
′	2	3.8%
”	2	3.8%
“	2	3.8%
‘	1	1.9%
–	1	1.9%

Cyrillic

Value	Count	Frequency (%)
е	37	10.7%
а	31	9.0%
о	29	8.4%
и	23	6.7%
н	23	6.7%
р	20	5.8%
с	16	4.6%
у	12	3.5%
л	11	3.2%
т	11	3.2%
Other values (31)	132	38.3%

None

Value	Count	Frequency (%)
é	31	31.6%
ø	16	16.3%
á	8	8.2%
Ø	4	4.1%
ꞌ	4	4.1%
à	3	3.1%
ó	3	3.1%
ñ	2	2.0%
ý	2	2.0%
É	2	2.0%
Other values (20)	23	23.5%

CJK

Value	Count	Frequency (%)
天	1	50.0%
泳	1	50.0%

Hebrew

Value	Count	Frequency (%)
ד	1	20.0%
ה	1	20.0%
מ	1	20.0%
ו	1	20.0%
ס	1	20.0%

Hangul

Value	Count	Frequency (%)
복	1	14.3%
스	1	14.3%
행	1	14.3%
강	1	14.3%
남	1	14.3%
타	1	14.3%
일	1	14.3%

Sup Punctuation

Value	Count	Frequency (%)
⸉	1	100.0%

Katakana

Value	Count	Frequency (%)
ム	1	20.0%
ス	1	20.0%
テ	1	20.0%
ィ	1	20.0%
ネ	1	20.0%

title
Categorical

HIGH CARDINALITY MISSING

Distinct	132
Distinct (%)	0.6%
Missing	21817
Missing (%)	50.9%
Memory size	335.2 KiB

Euphoric Hardstyle	1416
UKF Drum & Bass - All Uploads	921
Top Trance Songs EVER	782
I'm a fucking Headbanger	719
Dark Techno Rave	692
Other values (127)	16549

Length

Max length	49
Median length	37
Mean length	22.348546
Min length	4

Characters and Unicode

Total characters	471085
Distinct characters	71
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Dirtybird Players
2nd row	Tech House Movement
3rd row	tech house
4th row	Tech House Bangerz
5th row	tech house

Common Values

Value	Count	Frequency (%)
Euphoric Hardstyle	1416	3.3%
UKF Drum & Bass - All Uploads	921	2.1%
Top Trance Songs EVER	782	1.8%
I'm a fucking Headbanger	719	1.7%
Dark Techno Rave	692	1.6%
Liqduicity Drum & Bass	643	1.5%
PSYTRANCE BANGERS best new 2020	620	1.4%
Headbangers:Dubstep/Riddim	538	1.3%
Dirtybird//Techhouse by Mack\	518	1.2%
HEADBANGERS:Dubstep/Riddim	510	1.2%
Other values (122)	13720	32.0%
(Missing)	21817	50.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	5310	7.0%
2020	4148	5.5%
trance	3894	5.2%
hardstyle	3072	4.1%
techno	3065	4.1%
bass	3014	4.0%
drum	2963	3.9%
psytrance	2637	3.5%
euphoric	2066	2.7%
house	2065	2.7%
Other values (142)	43109	57.2%

Most occurring characters

Value	Count	Frequency (%)
	54284	11.5%
e	33420	7.1%
s	25916	5.5%
a	25025	5.3%
r	22909	4.9%
o	18765	4.0%
n	17752	3.8%
c	17585	3.7%
i	17407	3.7%
t	15676	3.3%
Other values (61)	222346	47.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	287208	61.0%
Uppercase Letter	87354	18.5%
Space Separator	54284	11.5%
Decimal Number	25729	5.5%
Other Punctuation	11290	2.4%
Dash Punctuation	2169	0.5%
Math Symbol	1141	0.2%
Close Punctuation	955	0.2%
Open Punctuation	955	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	33420	11.6%
s	25916	9.0%
a	25025	8.7%
r	22909	8.0%
o	18765	6.5%
n	17752	6.2%
c	17585	6.1%
i	17407	6.1%
t	15676	5.5%
d	14498	5.0%
Other values (16)	78255	27.2%

Uppercase Letter

Value	Count	Frequency (%)
T	12589	14.4%
D	8554	9.8%
H	7630	8.7%
E	7343	8.4%
R	6920	7.9%
B	5961	6.8%
A	4884	5.6%
P	4457	5.1%
S	3747	4.3%
N	3483	4.0%
Other values (13)	21786	24.9%

Other Punctuation

Value	Count	Frequency (%)
/	3353	29.7%
&	2564	22.7%
:	1656	14.7%
,	1098	9.7%
.	1073	9.5%
'	731	6.5%
\	518	4.6%
?	170	1.5%
!	127	1.1%

Decimal Number

Value	Count	Frequency (%)
0	11802	45.9%
2	10071	39.1%
1	1949	7.6%
8	666	2.6%
9	610	2.4%
5	279	1.1%
7	183	0.7%
4	169	0.7%

Space Separator

Value	Count	Frequency (%)
	54284	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2169	100.0%

Math Symbol

Value	Count	Frequency (%)
\|	1141	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	955	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	955	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	374562	79.5%
Common	96523	20.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	33420	8.9%
s	25916	6.9%
a	25025	6.7%
r	22909	6.1%
o	18765	5.0%
n	17752	4.7%
c	17585	4.7%
i	17407	4.6%
t	15676	4.2%
d	14498	3.9%
Other values (39)	165609	44.2%

Common

Value	Count	Frequency (%)
	54284	56.2%
0	11802	12.2%
2	10071	10.4%
/	3353	3.5%
&	2564	2.7%
-	2169	2.2%
1	1949	2.0%
:	1656	1.7%
\|	1141	1.2%
,	1098	1.1%
Other values (12)	6436	6.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	471085	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	54284	11.5%
e	33420	7.1%
s	25916	5.5%
a	25025	5.3%
r	22909	4.9%
o	18765	4.0%
n	17752	3.8%
c	17585	3.7%
i	17407	3.7%
t	15676	3.3%
Other values (61)	222346	47.2%

Auto

Heatmap
Table

	danceability	energy	key	loudness	speechiness	acousticness	instrumentalness	liveness	valence	tempo	duration_ms	mode	time_signature	genre
danceability	1.000	-0.372	-0.009	-0.265	0.255	0.212	-0.141	-0.232	0.358	-0.239	-0.109	0.086	0.074	0.243
energy	-0.372	1.000	0.037	0.568	-0.099	-0.534	0.385	0.212	-0.050	0.021	0.310	0.036	0.060	0.227
key	-0.009	0.037	1.000	-0.006	-0.015	-0.021	0.067	-0.011	0.027	-0.010	0.065	0.414	0.015	0.078
loudness	-0.265	0.568	-0.006	1.000	0.075	-0.179	-0.141	0.183	0.083	0.244	-0.050	0.026	0.046	0.227
speechiness	0.255	-0.099	-0.015	0.075	1.000	0.285	-0.429	0.073	0.272	0.186	-0.295	0.051	0.051	0.187
acousticness	0.212	-0.534	-0.021	-0.179	0.285	1.000	-0.508	-0.077	0.191	0.091	-0.399	0.026	0.063	0.166
instrumentalness	-0.141	0.385	0.067	-0.141	-0.429	-0.508	1.000	-0.053	-0.356	-0.228	0.524	0.033	0.032	0.293
liveness	-0.232	0.212	-0.011	0.183	0.073	-0.077	-0.053	1.000	-0.030	0.087	-0.056	0.000	0.011	0.118
valence	0.358	-0.050	0.027	0.083	0.272	0.191	-0.356	-0.030	1.000	0.055	-0.190	0.026	0.034	0.183
tempo	-0.239	0.021	-0.010	0.244	0.186	0.091	-0.228	0.087	0.055	1.000	-0.126	0.050	0.065	0.420
duration_ms	-0.109	0.310	0.065	-0.050	-0.295	-0.399	0.524	-0.056	-0.190	-0.126	1.000	0.080	0.045	0.323
mode	0.086	0.036	0.414	0.026	0.051	0.026	0.033	0.000	0.026	0.050	0.080	1.000	0.006	0.169
time_signature	0.074	0.060	0.015	0.046	0.051	0.063	0.032	0.011	0.034	0.065	0.045	0.006	1.000	0.083
genre	0.243	0.227	0.078	0.227	0.187	0.166	0.293	0.118	0.183	0.420	0.323	0.169	0.083	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	danceability	energy	key	loudness	mode	speechiness	acousticness	instrumentalness	liveness	valence	tempo	type	duration_ms	time_signature	genre	song_name	title
0	0.831	0.814	2	-7.364	1	0.4200	0.0598	0.013400	0.0556	0.3890	156.985	audio_features	124539	4	Dark Trap	Mercury: Retrograde	None
1	0.719	0.493	8	-7.230	1	0.0794	0.4010	0.000000	0.1180	0.1240	115.080	audio_features	224427	4	Dark Trap	Pathology	None
2	0.850	0.893	5	NaN	1	0.0623	0.0138	0.000004	0.3720	0.0391	218.050	audio_features	98821	4	Dark Trap	Symbiote	None
3	0.476	0.781	0	-4.710	1	0.1030	0.0237	0.000000	0.1140	0.1750	186.948	audio_features	123661	3	Dark Trap	ProductOfDrugs (Prod. The Virus and Antidote)	None
4	0.798	0.624	2	-7.668	1	0.2930	0.2170	0.000000	0.1660	0.5910	147.988	audio_features	123298	4	Dark Trap	Venom	None
5	0.721	0.568	0	-11.295	1	0.4140	0.0452	0.212000	0.1280	0.1090	144.915	audio_features	112511	4	Dark Trap	Gatteka	None
6	0.718	0.668	8	-4.162	1	0.1370	0.0254	0.007800	0.1240	0.0380	130.826	audio_features	77584	4	Dark Trap	kamikaze (+ pulse)	None
7	0.694	0.711	8	NaN	1	0.2210	0.0397	0.000000	0.1120	0.2830	138.049	audio_features	127524	3	Dark Trap	T.R.U. (Totally Rotten Underground)	None
8	0.774	0.751	1	-2.445	1	0.1980	0.0614	0.000000	0.0728	0.1890	219.960	audio_features	140326	4	Dark Trap	I Put My Dick in Your Mental	None
9	0.893	0.907	11	-10.406	1	0.3670	0.1520	0.031100	0.5580	0.3020	199.942	audio_features	121979	4	Dark Trap	Andromeda	None

	danceability	energy	key	loudness	mode	speechiness	acousticness	instrumentalness	liveness	valence	tempo	type	duration_ms	time_signature	genre	song_name	title
42886	0.875	0.753	8	-6.899	0	0.0901	0.040500	0.000099	0.1680	0.7350	112.002	audio_features	210187	4	Trap Metal	Smoke Break	None
42887	0.589	0.783	6	-11.170	1	0.0413	0.000421	0.916000	0.0839	0.0345	123.995	audio_features	410323	4	techno	None	Dark Techno Rave
42888	0.623	0.845	8	-9.082	1	0.0508	0.016000	0.864000	0.0862	0.3690	134.978	audio_features	546707	4	trance	None	Top Trance Songs EVER
42889	0.674	0.990	5	NaN	1	0.2840	0.312000	0.000016	0.6270	0.5090	173.948	audio_features	182069	4	dnb	None	UKF Drum & Bass - All Uploads
42890	0.653	0.944	2	NaN	1	0.0917	0.001630	0.473000	0.3520	0.0754	139.970	audio_features	221000	4	trance	None	TRANNCE 2020 Best Trance Music Official
42891	0.802	0.630	9	-9.348	0	0.4320	0.204000	0.000002	0.0649	0.8770	144.008	audio_features	66743	4	Underground Rap	Bang Bros!	None
42892	0.565	0.996	11	NaN	0	0.0682	0.000050	0.816000	0.9220	0.0658	145.000	audio_features	590875	4	psytrance	None	PSYTRANCE BANGERS best new 2020
42893	0.514	0.955	0	-5.182	0	0.0402	0.000053	0.889000	0.3380	0.1100	138.030	audio_features	221007	4	trance	None	Top Trance Songs EVER
42894	0.749	0.639	1	-9.841	1	0.1940	0.080900	0.609000	0.3620	0.6490	153.003	audio_features	215202	4	Underground Rap	Southern Hostility	None
42895	0.645	0.980	0	-6.898	1	0.0445	0.000029	0.843000	0.3180	0.2600	143.018	audio_features	443077	4	psytrance	None	Psytrance: From Full on to Forrest Trance

Most frequently occurring

	danceability	energy	key	loudness	mode	speechiness	acousticness	instrumentalness	liveness	valence	tempo	type	duration_ms	time_signature	genre	song_name	title	# duplicates
422	0.631	0.623	8	-6.969	1	0.2650	0.463000	0.000002	0.1510	0.7650	160.460	audio_features	227893	4	Hiphop	Everything I Am	NaN	4
60	0.389	0.768	1	-4.765	1	0.2560	0.038000	0.000000	0.1190	0.3340	90.146	audio_features	183567	4	Rap	WRONG (feat. Lil Mosey)	NaN	3
98	0.431	0.961	2	-6.598	0	0.0603	0.000246	0.207000	0.3680	0.1630	138.001	audio_features	235187	4	trance	NaN	TRANNCE 2020 Best Trance Music Official	3
146	0.473	0.735	11	-6.131	0	0.0498	0.010600	0.000000	0.2660	0.6500	154.546	audio_features	179453	4	Emo	You're So Last Summer	NaN	3
150	0.476	0.407	4	-9.239	0	0.0368	0.247000	0.000000	0.1440	0.2260	178.258	audio_features	242467	4	RnB	Officially Missing You	NaN	3
182	0.495	0.891	1	-5.599	0	0.0504	0.001870	0.112000	0.3220	0.2240	149.982	audio_features	142400	4	hardstyle	NaN	Euphoric Hardstyle & Melodic Hardstyle	3
219	0.513	0.855	8	-3.664	1	0.0375	0.029300	0.933000	0.3160	0.0367	173.996	audio_features	364149	4	dnb	NaN	Liquid Drum & Bass	3
285	0.548	0.554	9	-6.408	1	0.0587	0.283000	0.000000	0.0708	0.3820	159.836	audio_features	207507	4	RnB	Stickwitu	NaN	3
301	0.554	0.978	4	NaN	1	0.1310	0.111000	0.000000	0.0731	0.5940	135.095	audio_features	162600	4	Emo	Faint	NaN	3
419	0.629	0.696	1	-5.572	0	0.3480	0.019500	0.000000	0.0554	0.6230	186.068	audio_features	207627	4	Hiphop	Gold Digger	NaN	3

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Letter

Other Punctuation

Decimal Number

Math Symbol

Open Punctuation

Close Punctuation

Initial Punctuation

Dash Punctuation

Final Punctuation

Space Separator

Currency Symbol

Connector Punctuation

Other Symbol

Most occurring scripts

Most frequent character per script